USE [ANTS_NetServer]
GO
/****** Object:  StoredProcedure [dbo].[proc_NVRDeviceInfoAndDeviceInfo_select]    Script Date: 04/21/2013 21:28:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[proc_NVRDeviceInfoAndDeviceInfo_select](
	@username varchar(20)
)
	
 as
 select a.deviceSN,a.username,a.deviceLoc
   from DeviceInfo_t b,NVRDeviceInfo a where
 a.deviceSN=b.Sn and a.username=@username